
-- Add new int field
IF NOT EXISTS(SELECT [Name] FROM syscolumns WHERE Name = 'InputPrice' AND ID = OBJECT_ID('dbo.BillDetail'))
   ALTER TABLE BillDetail ADD InputPrice INT NULL